Overview

Brought to you by YData

Dataset statistics

Number of variables	24
Number of observations	182242
Missing cells	736673
Missing cells (%)	16.8%
Duplicate rows	3051
Duplicate rows (%)	1.7%
Total size in memory	33.4 MiB
Average record size in memory	192.0 B

Variable types

Categorical	4
Numeric	13
Text	7

Alerts

Dataset has 3051 (1.7%) duplicate rows	Duplicates
`BDRM_COND` is highly overall correlated with `GROSS_AREA` and 2 other fields	High correlation
`BED_RMS` is highly overall correlated with `FULL_BTH` and 5 other fields	High correlation
`CITY` is highly overall correlated with `ZIP_CODE`	High correlation
`FULL_BTH` is highly overall correlated with `BED_RMS` and 2 other fields	High correlation
`GROSS_AREA` is highly overall correlated with `BDRM_COND` and 5 other fields	High correlation
`KITCHENS` is highly overall correlated with `BED_RMS` and 2 other fields	High correlation
`LIVING_AREA` is highly overall correlated with `BDRM_COND` and 4 other fields	High correlation
`NUM_PARKING` is highly overall correlated with `BDRM_COND` and 1 other fields	High correlation
`RES_FLOOR` is highly overall correlated with `BED_RMS` and 3 other fields	High correlation
`STRUCTURE_CLASS` is highly overall correlated with `YR_BUILT`	High correlation
`TT_RMS` is highly overall correlated with `BED_RMS` and 5 other fields	High correlation
`YR_BUILT` is highly overall correlated with `STRUCTURE_CLASS`	High correlation
`ZIP_CODE` is highly overall correlated with `CITY`	High correlation
`NUM_BLDGS` is highly imbalanced (99.9%)	Imbalance
`BDRM_COND` is highly imbalanced (61.9%)	Imbalance
`BLDG_TYPE` has 2616 (1.4%) missing values	Missing
`RES_FLOOR` has 33792 (18.5%) missing values	Missing
`LAND_SF` has 8002 (4.4%) missing values	Missing
`GROSS_AREA` has 33848 (18.6%) missing values	Missing
`LIVING_AREA` has 34141 (18.7%) missing values	Missing
`YR_BUILT` has 22786 (12.5%) missing values	Missing
`YR_REMODEL` has 95524 (52.4%) missing values	Missing
`STRUCTURE_CLASS` has 164836 (90.4%) missing values	Missing
`BED_RMS` has 48765 (26.8%) missing values	Missing
`FULL_BTH` has 11644 (6.4%) missing values	Missing
`HLF_BTH` has 11509 (6.3%) missing values	Missing
`KITCHENS` has 11718 (6.4%) missing values	Missing
`TT_RMS` has 48829 (26.8%) missing values	Missing
`BDRM_COND` has 110500 (60.6%) missing values	Missing
`FIREPLACES` has 49534 (27.2%) missing values	Missing
`NUM_PARKING` has 48623 (26.7%) missing values	Missing
`GROSS_AREA` is highly skewed (γ1 = 55.89596558)	Skewed
`LIVING_AREA` is highly skewed (γ1 = 63.65241616)	Skewed
`YR_BUILT` is highly skewed (γ1 = 146.1067555)	Skewed
`YR_REMODEL` is highly skewed (γ1 = 248.0727809)	Skewed
`NUM_PARKING` is highly skewed (γ1 = 29.67993455)	Skewed
`BED_RMS` has 3184 (1.7%) zeros	Zeros
`FULL_BTH` has 36940 (20.3%) zeros	Zeros
`HLF_BTH` has 135661 (74.4%) zeros	Zeros
`KITCHENS` has 36863 (20.2%) zeros	Zeros
`FIREPLACES` has 96980 (53.2%) zeros	Zeros
`NUM_PARKING` has 58524 (32.1%) zeros	Zeros

Reproduction

Analysis started	2024-11-05 22:53:06.970948
Analysis finished	2024-11-05 22:53:46.170117
Duration	39.2 seconds
Software version	ydata-profiling vv4.12.0
Download configuration	config.json

CITY
Categorical

High correlation

Distinct	19
Distinct (%)	< 0.1%
Missing	3
Missing (%)	< 0.1%
Memory size	1.4 MiB

BOSTON	47713
DORCHESTER	29328
SOUTH BOSTON	15622
JAMAICA PLAIN	12147
BRIGHTON	12113
Other values (14)	65316

Length

Max length	16
Median length	12
Mean length	9.206937
Min length	6

Characters and Unicode

Total characters	1677863
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	EAST BOSTON
2nd row	EAST BOSTON
3rd row	EAST BOSTON
4th row	EAST BOSTON
5th row	EAST BOSTON

Common Values

Value	Count	Frequency (%)
BOSTON	47713	26.2%
DORCHESTER	29328	16.1%
SOUTH BOSTON	15622	8.6%
JAMAICA PLAIN	12147	6.7%
BRIGHTON	12113	6.6%
WEST ROXBURY	11006	6.0%
EAST BOSTON	10233	5.6%
ROSLINDALE	9279	5.1%
HYDE PARK	9192	5.0%
CHARLESTOWN	7252	4.0%
Other values (9)	18354	10.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
boston	73568	30.2%
dorchester	29328	12.1%
roxbury	18991	7.8%
south	15622	6.4%
plain	12147	5.0%
jamaica	12147	5.0%
brighton	12113	5.0%
west	11006	4.5%
east	10233	4.2%
roslindale	9279	3.8%
Other values (12)	38868	16.0%

Most occurring characters

Value	Count	Frequency (%)
O	246073	14.7%
T	175338	10.5%
S	165454	9.9%
R	136346	8.1%
N	126567	7.5%
E	106670	6.4%
B	104696	6.2%
A	103595	6.2%
H	75547	4.5%
	61063	3.6%
Other values (14)	376514	22.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1677863	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
O	246073	14.7%
T	175338	10.5%
S	165454	9.9%
R	136346	8.1%
N	126567	7.5%
E	106670	6.4%
B	104696	6.2%
A	103595	6.2%
H	75547	4.5%
	61063	3.6%
Other values (14)	376514	22.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1677863	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
O	246073	14.7%
T	175338	10.5%
S	165454	9.9%
R	136346	8.1%
N	126567	7.5%
E	106670	6.4%
B	104696	6.2%
A	103595	6.2%
H	75547	4.5%
	61063	3.6%
Other values (14)	376514	22.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1677863	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
O	246073	14.7%
T	175338	10.5%
S	165454	9.9%
R	136346	8.1%
N	126567	7.5%
E	106670	6.4%
B	104696	6.2%
A	103595	6.2%
H	75547	4.5%
	61063	3.6%
Other values (14)	376514	22.4%

ZIP_CODE
Real number (ℝ)

High correlation

Distinct	37
Distinct (%)	< 0.1%
Missing	3
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	2129.8679

Minimum	2026
Maximum	2467
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	2026
5-th percentile	2111
Q1	2119
median	2127
Q3	2131
95-th percentile	2136
Maximum	2467
Range	441
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	30.721915
Coefficient of variation (CV)	0.014424328
Kurtosis	81.218517
Mean	2129.8679
Median Absolute Deviation (MAD)	5
Skewness	8.1238643
Sum	3.88145 × 10⁸
Variance	943.83603
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=37)

Value	Count	Frequency (%)
2127	15656	8.6%
2130	12154	6.7%
2135	12114	6.6%
2124	11124	6.1%
2132	11004	6.0%
2128	10231	5.6%
2116	9649	5.3%
2118	9384	5.1%
2131	9283	5.1%
2136	9192	5.0%
Other values (27)	72448	39.8%

Value	Count	Frequency (%)
2026	6	< 0.1%
2108	2172	1.2%
2109	1847	1.0%
2110	2487	1.4%
2111	2893	1.6%
2113	2357	1.3%
2114	5352	2.9%
2115	5548	3.0%
2116	9649	5.3%
2118	9384	5.1%

Value	Count	Frequency (%)
2467	1017	0.6%
2458	1	< 0.1%
2446	11	< 0.1%
2445	13	< 0.1%
2219	1	< 0.1%
2215	3649	2.0%
2210	2132	1.2%
2201	3	< 0.1%
2199	36	< 0.1%
2137	2	< 0.1%

NUM_BLDGS
Categorical

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

1	182228
2	14

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	182242
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	182228	> 99.9%
2	14	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	182228	> 99.9%
2	14	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
1	182228	> 99.9%
2	14	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	182242	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	182228	> 99.9%
2	14	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	182242	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	182228	> 99.9%
2	14	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	182242	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	182228	> 99.9%
2	14	< 0.1%

LU_DESC
Text

Distinct	194
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Length

Max length	28
Median length	26
Mean length	16.888231
Min length	5

Characters and Unicode

Total characters	3077745
Distinct characters	68
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	16 ?
Unique (%)	< 0.1%

Sample

1st row	THREE-FAM DWELLING
2nd row	THREE-FAM DWELLING
3rd row	THREE-FAM DWELLING
4th row	THREE-FAM DWELLING
5th row	TWO-FAM DWELLING

Value	Count	Frequency (%)
condo	92825	21.9%
residential	72979	17.2%
dwelling	60551	14.3%
single	30439	7.2%
fam	30439	7.2%
two-fam	16814	4.0%
res	15805	3.7%
three-fam	13298	3.1%
main	10768	2.5%
parking	8987	2.1%
Other values (264)	71041	16.8%

Most occurring characters

Value	Count	Frequency (%)
E	306547	10.0%
N	293643	9.5%
I	277658	9.0%
L	247639	8.0%
	241900	7.9%
D	239004	7.8%
O	225960	7.3%
A	176683	5.7%
S	140752	4.6%
T	130272	4.2%
Other values (58)	797687	25.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3077745	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
E	306547	10.0%
N	293643	9.5%
I	277658	9.0%
L	247639	8.0%
	241900	7.9%
D	239004	7.8%
O	225960	7.3%
A	176683	5.7%
S	140752	4.6%
T	130272	4.2%
Other values (58)	797687	25.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3077745	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
E	306547	10.0%
N	293643	9.5%
I	277658	9.0%
L	247639	8.0%
	241900	7.9%
D	239004	7.8%
O	225960	7.3%
A	176683	5.7%
S	140752	4.6%
T	130272	4.2%
Other values (58)	797687	25.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3077745	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
E	306547	10.0%
N	293643	9.5%
I	277658	9.0%
L	247639	8.0%
	241900	7.9%
D	239004	7.8%
O	225960	7.3%
A	176683	5.7%
S	140752	4.6%
T	130272	4.2%
Other values (58)	797687	25.9%

BLDG_TYPE
Text

Missing

Distinct	201
Distinct (%)	0.1%
Missing	2616
Missing (%)	1.4%
Memory size	1.4 MiB

Length

Max length	34
Median length	31
Mean length	13.795586
Min length	1

Characters and Unicode

Total characters	2478046
Distinct characters	69
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	12 ?
Unique (%)	< 0.1%

Sample

1st row	RE - Row End
2nd row	RM - Row Middle
3rd row	RM - Row Middle
4th row	RM - Row Middle
5th row	RE - Row End

Value	Count	Frequency (%)
	168505	26.6%
rise	38625	6.1%
row	26473	4.2%
rm	17763	2.8%
middle	17698	2.8%
cl	16789	2.6%
colonial	16789	2.6%
lr	15448	2.4%
low	15448	2.4%
mr	15194	2.4%
Other values (462)	285650	45.0%

Most occurring characters

Value	Count	Frequency (%)
	454951	18.4%
-	179927	7.3%
R	147705	6.0%
e	145112	5.9%
i	129604	5.2%
o	126568	5.1%
n	106689	4.3%
d	85062	3.4%
a	82052	3.3%
l	79352	3.2%
Other values (59)	941024	38.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2478046	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	454951	18.4%
-	179927	7.3%
R	147705	6.0%
e	145112	5.9%
i	129604	5.2%
o	126568	5.1%
n	106689	4.3%
d	85062	3.4%
a	82052	3.3%
l	79352	3.2%
Other values (59)	941024	38.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2478046	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	454951	18.4%
-	179927	7.3%
R	147705	6.0%
e	145112	5.9%
i	129604	5.2%
o	126568	5.1%
n	106689	4.3%
d	85062	3.4%
a	82052	3.3%
l	79352	3.2%
Other values (59)	941024	38.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2478046	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	454951	18.4%
-	179927	7.3%
R	147705	6.0%
e	145112	5.9%
i	129604	5.2%
o	126568	5.1%
n	106689	4.3%
d	85062	3.4%
a	82052	3.3%
l	79352	3.2%
Other values (59)	941024	38.0%

RES_FLOOR
Real number (ℝ)

High correlation Missing

Distinct	48
Distinct (%)	< 0.1%
Missing	33792
Missing (%)	18.5%
Infinite	0
Infinite (%)	0.0%
Mean	1.8803537

Minimum	0
Maximum	62
Zeros	31
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	2
Q3	2.5
95-th percentile	3
Maximum	62
Range	62
Interquartile range (IQR)	1.5

Descriptive statistics

Standard deviation	1.1290417
Coefficient of variation (CV)	0.60044113
Kurtosis	321.52964
Mean	1.8803537
Median Absolute Deviation (MAD)	1
Skewness	9.6638775
Sum	279138.5
Variance	1.2747351
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=48)

Value	Count	Frequency (%)
1	63070	34.6%
2	42412	23.3%
3	24604	13.5%
2.5	7712	4.2%
4	4616	2.5%
1.5	3505	1.9%
5	1360	0.7%
3.5	487	0.3%
6	237	0.1%
4.5	105	0.1%
Other values (38)	342	0.2%
(Missing)	33792	18.5%

Value	Count	Frequency (%)
0	31	< 0.1%
1	63070	34.6%
1.5	3505	1.9%
2	42412	23.3%
2.5	7712	4.2%
3	24604	13.5%
3.5	487	0.3%
4	4616	2.5%
4.5	105	0.1%
5	1360	0.7%

Value	Count	Frequency (%)
62	1	< 0.1%
60	2	< 0.1%
46	3	< 0.1%
45	1	< 0.1%
41	2	< 0.1%
40	1	< 0.1%
39	2	< 0.1%
36	1	< 0.1%
35	1	< 0.1%
33	1	< 0.1%

LAND_SF
Text

Missing

Distinct	17559
Distinct (%)	10.1%
Missing	8002
Missing (%)	4.4%
Memory size	1.4 MiB

Length

Max length	11
Median length	5
Mean length	4.5646235
Min length	3

Characters and Unicode

Total characters	795340
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	7616 ?
Unique (%)	4.4%

Sample

1st row	1,150
2nd row	1,150
3rd row	1,150
4th row	1,150
5th row	2,010

Value	Count	Frequency (%)
5,000	2392	1.4%
4,000	1353	0.8%
2,500	862	0.5%
6,000	858	0.5%
4,500	671	0.4%
5,500	641	0.4%
3,600	536	0.3%
3,200	492	0.3%
3,000	490	0.3%
2,000	347	0.2%
Other values (17549)	165598	95.0%

Most occurring characters

Value	Count	Frequency (%)
,	130489	16.4%
0	106022	13.3%
1	93910	11.8%
5	73860	9.3%
2	66439	8.4%
4	60552	7.6%
3	59000	7.4%
6	57057	7.2%
7	52775	6.6%
8	50775	6.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	795340	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
,	130489	16.4%
0	106022	13.3%
1	93910	11.8%
5	73860	9.3%
2	66439	8.4%
4	60552	7.6%
3	59000	7.4%
6	57057	7.2%
7	52775	6.6%
8	50775	6.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	795340	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
,	130489	16.4%
0	106022	13.3%
1	93910	11.8%
5	73860	9.3%
2	66439	8.4%
4	60552	7.6%
3	59000	7.4%
6	57057	7.2%
7	52775	6.6%
8	50775	6.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	795340	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
,	130489	16.4%
0	106022	13.3%
1	93910	11.8%
5	73860	9.3%
2	66439	8.4%
4	60552	7.6%
3	59000	7.4%
6	57057	7.2%
7	52775	6.6%
8	50775	6.4%

GROSS_AREA
Real number (ℝ)

High correlation Missing Skewed

Distinct	13098
Distinct (%)	8.8%
Missing	33848
Missing (%)	18.6%
Infinite	0
Infinite (%)	0.0%
Mean	5434.6768

Minimum	3
Maximum	6982322
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	3
5-th percentile	544
Q1	967
median	2085
Q3	4008
95-th percentile	7770.7
Maximum	6982322
Range	6982319
Interquartile range (IQR)	3041

Descriptive statistics

Standard deviation	41322.818
Coefficient of variation (CV)	7.6035465
Kurtosis	6477.9546
Mean	5434.6768
Median Absolute Deviation (MAD)	1271
Skewness	55.895966
Sum	8.0647342 × 10⁸
Variance	1.7075753 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
780	282	0.2%
600	237	0.1%
700	230	0.1%
625	220	0.1%
690	214	0.1%
800	213	0.1%
1050	211	0.1%
760	210	0.1%
775	203	0.1%
730	197	0.1%
Other values (13088)	146177	80.2%
(Missing)	33848	18.6%

Value	Count	Frequency (%)
3	1	< 0.1%
4	1	< 0.1%
25	1	< 0.1%
42	1	< 0.1%
60	1	< 0.1%
82	1	< 0.1%
90	1	< 0.1%
100	125	0.1%
102	1	< 0.1%
106	1	< 0.1%

Value	Count	Frequency (%)
6982322	1	< 0.1%
3064910	1	< 0.1%
2948448	1	< 0.1%
2481232	1	< 0.1%
2310322	1	< 0.1%
1976650	1	< 0.1%
1970176	1	< 0.1%
1933059	1	< 0.1%
1772572	1	< 0.1%
1726152	1	< 0.1%

LIVING_AREA
Real number (ℝ)

High correlation Missing Skewed

Distinct	21808
Distinct (%)	14.7%
Missing	34141
Missing (%)	18.7%
Infinite	0
Infinite (%)	0.0%
Mean	4437.7612

Minimum	2
Maximum	6982322
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	2
5-th percentile	542
Q1	942
median	1483.5
Q3	2600
95-th percentile	5768
Maximum	6982322
Range	6982320
Interquartile range (IQR)	1658

Descriptive statistics

Standard deviation	38453.214
Coefficient of variation (CV)	8.665003
Kurtosis	8373.4206
Mean	4437.7612
Median Absolute Deviation (MAD)	689.5
Skewness	63.652416
Sum	6.5723688 × 10⁸
Variance	1.4786497 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
780	291	0.2%
800	263	0.1%
1008	261	0.1%
1050	250	0.1%
1224	243	0.1%
600	239	0.1%
700	235	0.1%
625	223	0.1%
1000	222	0.1%
960	221	0.1%
Other values (21798)	145653	79.9%
(Missing)	34141	18.7%

Value	Count	Frequency (%)
2	1	< 0.1%
25	1	< 0.1%
42	1	< 0.1%
82	1	< 0.1%
90	1	< 0.1%
100	122	0.1%
102	1	< 0.1%
106	1	< 0.1%
108	1	< 0.1%
112	4	< 0.1%

Value	Count	Frequency (%)
6982322	1	< 0.1%
2898078	1	< 0.1%
2882794	1	< 0.1%
2413114	1	< 0.1%
2310322	1	< 0.1%
1940476	1	< 0.1%
1885420	1	< 0.1%
1694084	1	< 0.1%
1595056	1	< 0.1%
1504200	1	< 0.1%

LAND_VALUE
Text

Distinct	16658
Distinct (%)	9.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Length

Max length	11
Median length	1
Mean length	3.909697
Min length	1

Characters and Unicode

Total characters	712511
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	9985 ?
Unique (%)	5.5%

Sample

1st row	197,600
2nd row	198,500
3rd row	199,100
4th row	199,700
5th row	230,200

Value	Count	Frequency (%)
0	94289	51.7%
218,300	66	< 0.1%
203,200	63	< 0.1%
238,200	59	< 0.1%
250,000	58	< 0.1%
229,900	57	< 0.1%
218,500	57	< 0.1%
240,900	57	< 0.1%
239,800	57	< 0.1%
233,500	57	< 0.1%
Other values (16648)	87422	48.0%

Most occurring characters

Value	Count	Frequency (%)
0	288645	40.5%
,	94143	13.2%
2	63438	8.9%
1	51469	7.2%
3	39788	5.6%
4	32613	4.6%
5	30068	4.2%
6	28788	4.0%
7	28041	3.9%
8	27791	3.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	712511	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	288645	40.5%
,	94143	13.2%
2	63438	8.9%
1	51469	7.2%
3	39788	5.6%
4	32613	4.6%
5	30068	4.2%
6	28788	4.0%
7	28041	3.9%
8	27791	3.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	712511	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	288645	40.5%
,	94143	13.2%
2	63438	8.9%
1	51469	7.2%
3	39788	5.6%
4	32613	4.6%
5	30068	4.2%
6	28788	4.0%
7	28041	3.9%
8	27791	3.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	712511	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	288645	40.5%
,	94143	13.2%
2	63438	8.9%
1	51469	7.2%
3	39788	5.6%
4	32613	4.6%
5	30068	4.2%
6	28788	4.0%
7	28041	3.9%
8	27791	3.9%

BLDG_VALUE
Text

Distinct	28352
Distinct (%)	15.6%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Length

Max length	13
Median length	7
Mean length	6.5419278
Min length	1

Characters and Unicode

Total characters	1192214
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	14035 ?
Unique (%)	7.7%

Sample

1st row	594,400
2nd row	619,700
3rd row	605,300
4th row	535,600
5th row	501,400

Value	Count	Frequency (%)
0	20018	11.0%
200	2213	1.2%
60,000	674	0.4%
40,000	565	0.3%
43,000	481	0.3%
90,000	342	0.2%
38,000	308	0.2%
74,600	305	0.2%
48,000	280	0.2%
108,000	275	0.2%
Other values (28342)	156781	86.0%

Most occurring characters

Value	Count	Frequency (%)
0	396479	33.3%
,	187305	15.7%
4	77028	6.5%
3	74480	6.2%
1	74375	6.2%
5	71824	6.0%
6	67827	5.7%
2	67112	5.6%
7	62524	5.2%
8	58227	4.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1192214	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	396479	33.3%
,	187305	15.7%
4	77028	6.5%
3	74480	6.2%
1	74375	6.2%
5	71824	6.0%
6	67827	5.7%
2	67112	5.6%
7	62524	5.2%
8	58227	4.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1192214	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	396479	33.3%
,	187305	15.7%
4	77028	6.5%
3	74480	6.2%
1	74375	6.2%
5	71824	6.0%
6	67827	5.7%
2	67112	5.6%
7	62524	5.2%
8	58227	4.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1192214	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	396479	33.3%
,	187305	15.7%
4	77028	6.5%
3	74480	6.2%
1	74375	6.2%
5	71824	6.0%
6	67827	5.7%
2	67112	5.6%
7	62524	5.2%
8	58227	4.9%

TOTAL_VALUE
Text

Distinct	32201
Distinct (%)	17.7%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Length

Max length	13
Median length	7
Mean length	7.0112323
Min length	1

Characters and Unicode

Total characters	1277741
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	15263 ?
Unique (%)	8.4%

Sample

1st row	792,000
2nd row	818,200
3rd row	804,400
4th row	735,300
5th row	731,600

Value	Count	Frequency (%)
0	10774	5.9%
60,000	681	0.4%
40,000	580	0.3%
43,000	491	0.3%
90,000	345	0.2%
38,000	318	0.2%
74,600	307	0.2%
48,000	293	0.2%
108,000	277	0.2%
47,000	272	0.1%
Other values (32191)	167904	92.1%

Most occurring characters

Value	Count	Frequency (%)
0	413329	32.3%
,	212603	16.6%
1	90965	7.1%
4	76178	6.0%
5	74929	5.9%
6	73504	5.8%
3	71845	5.6%
7	69909	5.5%
2	67851	5.3%
8	64956	5.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1277741	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	413329	32.3%
,	212603	16.6%
1	90965	7.1%
4	76178	6.0%
5	74929	5.9%
6	73504	5.8%
3	71845	5.6%
7	69909	5.5%
2	67851	5.3%
8	64956	5.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1277741	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	413329	32.3%
,	212603	16.6%
1	90965	7.1%
4	76178	6.0%
5	74929	5.9%
6	73504	5.8%
3	71845	5.6%
7	69909	5.5%
2	67851	5.3%
8	64956	5.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1277741	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	413329	32.3%
,	212603	16.6%
1	90965	7.1%
4	76178	6.0%
5	74929	5.9%
6	73504	5.8%
3	71845	5.6%
7	69909	5.5%
2	67851	5.3%
8	64956	5.1%

GROSS_TAX
Text

Distinct	34946
Distinct (%)	19.2%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Length

Max length	15
Median length	10
Mean length	9.7160369
Min length	6

Characters and Unicode

Total characters	1770670
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	18669 ?
Unique (%)	10.2%

Sample

1st row	$8,632.80
2nd row	$8,918.38
3rd row	$8,767.96
4th row	$8,014.77
5th row	$7,974.44

Value	Count	Frequency (%)
	18617	10.2%
654.00	676	0.4%
436.00	577	0.3%
468.70	441	0.2%
981.00	343	0.2%
813.14	305	0.2%
523.20	290	0.2%
414.20	286	0.2%
1,177.20	276	0.2%
512.30	268	0.1%
Other values (34936)	160163	87.9%

Most occurring characters

Value	Count	Frequency (%)
	238093	13.4%
$	182242	10.3%
.	163625	9.2%
,	150824	8.5%
1	127167	7.2%
6	103329	5.8%
4	102418	5.8%
5	101394	5.7%
7	99792	5.6%
3	99129	5.6%
Other values (5)	402657	22.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1770670	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	238093	13.4%
$	182242	10.3%
.	163625	9.2%
,	150824	8.5%
1	127167	7.2%
6	103329	5.8%
4	102418	5.8%
5	101394	5.7%
7	99792	5.6%
3	99129	5.6%
Other values (5)	402657	22.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1770670	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	238093	13.4%
$	182242	10.3%
.	163625	9.2%
,	150824	8.5%
1	127167	7.2%
6	103329	5.8%
4	102418	5.8%
5	101394	5.7%
7	99792	5.6%
3	99129	5.6%
Other values (5)	402657	22.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1770670	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	238093	13.4%
$	182242	10.3%
.	163625	9.2%
,	150824	8.5%
1	127167	7.2%
6	103329	5.8%
4	102418	5.8%
5	101394	5.7%
7	99792	5.6%
3	99129	5.6%
Other values (5)	402657	22.7%

YR_BUILT
Real number (ℝ)

High correlation Missing Skewed

Distinct	236
Distinct (%)	0.1%
Missing	22786
Missing (%)	12.5%
Infinite	0
Infinite (%)	0.0%
Mean	1933.2157

Minimum	1700
Maximum	20198
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	1700
5-th percentile	1880
Q1	1900
median	1920
Q3	1965
95-th percentile	2017
Maximum	20198
Range	18498
Interquartile range (IQR)	65

Descriptive statistics

Standard deviation	63.981908
Coefficient of variation (CV)	0.033096104
Kurtosis	41646.839
Mean	1933.2157
Median Absolute Deviation (MAD)	21
Skewness	146.10676
Sum	3.0826284 × 10⁸
Variance	4093.6845
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1900	17988	9.9%
1920	12195	6.7%
1910	11790	6.5%
1905	10567	5.8%
1899	9866	5.4%
1890	8985	4.9%
1930	4176	2.3%
1999	3820	2.1%
1925	3785	2.1%
1880	3320	1.8%
Other values (226)	72964	40.0%
(Missing)	22786	12.5%

Value	Count	Frequency (%)
1700	1	< 0.1%
1710	1	< 0.1%
1725	2	< 0.1%
1752	2	< 0.1%
1760	1	< 0.1%
1775	1	< 0.1%
1779	1	< 0.1%
1780	1	< 0.1%
1785	2	< 0.1%
1789	1	< 0.1%

Value	Count	Frequency (%)
20198	1	< 0.1%
2023	8	< 0.1%
2022	340	0.2%
2021	1224	0.7%
2020	1613	0.9%
2019	1158	0.6%
2018	2437	1.3%
2017	2185	1.2%
2016	1603	0.9%
2015	1392	0.8%

YR_REMODEL
Real number (ℝ)

Missing Skewed

Distinct	106
Distinct (%)	0.1%
Missing	95524
Missing (%)	52.4%
Infinite	0
Infinite (%)	0.0%
Mean	2002.0116

Minimum	0
Maximum	20220
Zeros	2
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	0
5-th percentile	1979
Q1	1987
median	2005
Q3	2016
95-th percentile	2021
Maximum	20220
Range	20220
Interquartile range (IQR)	29

Descriptive statistics

Standard deviation	65.386476
Coefficient of variation (CV)	0.032660387
Kurtosis	69535.907
Mean	2002.0116
Median Absolute Deviation (MAD)	12
Skewness	248.07278
Sum	1.7361045 × 10⁸
Variance	4275.3912
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1985	3962	2.2%
2017	3910	2.1%
2021	3361	1.8%
2005	3207	1.8%
2019	3124	1.7%
1980	3112	1.7%
2018	3029	1.7%
2016	2893	1.6%
2022	2718	1.5%
2004	2711	1.5%
Other values (96)	54691	30.0%
(Missing)	95524	52.4%

Value	Count	Frequency (%)
0	2	< 0.1%
201	2	< 0.1%
221	1	< 0.1%
1900	9	< 0.1%
1902	1	< 0.1%
1904	1	< 0.1%
1910	1	< 0.1%
1914	3	< 0.1%
1915	1	< 0.1%
1916	2	< 0.1%

Value	Count	Frequency (%)
20220	1	< 0.1%
2921	1	< 0.1%
2121	1	< 0.1%
2023	118	0.1%
2022	2718	1.5%
2021	3361	1.8%
2020	2624	1.4%
2019	3124	1.7%
2018	3029	1.7%
2017	3910	2.1%

STRUCTURE_CLASS
Categorical

High correlation Missing

Distinct	5
Distinct (%)	< 0.1%
Missing	164836
Missing (%)	90.4%
Memory size	1.4 MiB

C - Brick/Concr	10201
D - Wood/Frame	4528
B - Reinf Concr	1649
A - Struct Steel	925
E - Metal	103

Length

Max length	16
Median length	15
Mean length	14.757497
Min length	9

Characters and Unicode

Total characters	256869
Distinct characters	27
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	D - Wood/Frame
2nd row	D - Wood/Frame
3rd row	D - Wood/Frame
4th row	D - Wood/Frame
5th row	D - Wood/Frame

Common Values

Value	Count	Frequency (%)
C - Brick/Concr	10201	5.6%
D - Wood/Frame	4528	2.5%
B - Reinf Concr	1649	0.9%
A - Struct Steel	925	0.5%
E - Metal	103	0.1%
(Missing)	164836	90.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
	17406	31.8%
c	10201	18.6%
brick/concr	10201	18.6%
d	4528	8.3%
wood/frame	4528	8.3%
b	1649	3.0%
reinf	1649	3.0%
concr	1649	3.0%
a	925	1.7%
struct	925	1.7%
Other values (3)	1131	2.1%

Most occurring characters

Value	Count	Frequency (%)
	37386	14.6%
r	27504	10.7%
c	22976	8.9%
C	22051	8.6%
o	20906	8.1%
-	17406	6.8%
/	14729	5.7%
n	13499	5.3%
B	11850	4.6%
i	11850	4.6%
Other values (17)	56712	22.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	256869	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	37386	14.6%
r	27504	10.7%
c	22976	8.9%
C	22051	8.6%
o	20906	8.1%
-	17406	6.8%
/	14729	5.7%
n	13499	5.3%
B	11850	4.6%
i	11850	4.6%
Other values (17)	56712	22.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	256869	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	37386	14.6%
r	27504	10.7%
c	22976	8.9%
C	22051	8.6%
o	20906	8.1%
-	17406	6.8%
/	14729	5.7%
n	13499	5.3%
B	11850	4.6%
i	11850	4.6%
Other values (17)	56712	22.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	256869	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	37386	14.6%
r	27504	10.7%
c	22976	8.9%
C	22051	8.6%
o	20906	8.1%
-	17406	6.8%
/	14729	5.7%
n	13499	5.3%
B	11850	4.6%
i	11850	4.6%
Other values (17)	56712	22.1%

BED_RMS
Real number (ℝ)

High correlation Missing Zeros

Distinct	19
Distinct (%)	< 0.1%
Missing	48765
Missing (%)	26.8%
Infinite	0
Infinite (%)	0.0%
Mean	3.1484376

Minimum	0
Maximum	21
Zeros	3184
Zeros (%)	1.7%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	3
Q3	4
95-th percentile	8
Maximum	21
Range	21
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	2.1022194
Coefficient of variation (CV)	0.66770242
Kurtosis	2.2563752
Mean	3.1484376
Median Absolute Deviation (MAD)	1
Skewness	1.3651924
Sum	420244
Variance	4.4193264
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=19)

Value	Count	Frequency (%)
2	38002	20.9%
3	27552	15.1%
1	22279	12.2%
4	15328	8.4%
6	9957	5.5%
5	8124	4.5%
9	3275	1.8%
0	3184	1.7%
8	2297	1.3%
7	2208	1.2%
Other values (9)	1271	0.7%
(Missing)	48765	26.8%

Value	Count	Frequency (%)
0	3184	1.7%
1	22279	12.2%
2	38002	20.9%
3	27552	15.1%
4	15328	8.4%
5	8124	4.5%
6	9957	5.5%
7	2208	1.2%
8	2297	1.3%
9	3275	1.8%

Value	Count	Frequency (%)
21	1	< 0.1%
17	5	< 0.1%
16	2	< 0.1%
15	27	< 0.1%
14	54	< 0.1%
13	32	< 0.1%
12	351	0.2%
11	407	0.2%
10	392	0.2%
9	3275	1.8%

FULL_BTH
Real number (ℝ)

High correlation Missing Zeros

Distinct	17
Distinct (%)	< 0.1%
Missing	11644
Missing (%)	6.4%
Infinite	0
Infinite (%)	0.0%
Mean	1.359758

Minimum	0
Maximum	21
Zeros	36940
Zeros (%)	20.3%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	1
Q3	2
95-th percentile	3
Maximum	21
Range	21
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.0605678
Coefficient of variation (CV)	0.77996806
Kurtosis	3.1724521
Mean	1.359758
Median Absolute Deviation (MAD)	1
Skewness	0.921087
Sum	231972
Variance	1.1248041
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
1	64877	35.6%
2	45213	24.8%
0	36940	20.3%
3	19794	10.9%
4	2551	1.4%
6	580	0.3%
5	519	0.3%
7	65	< 0.1%
8	35	< 0.1%
9	12	< 0.1%
Other values (7)	12	< 0.1%
(Missing)	11644	6.4%

Value	Count	Frequency (%)
0	36940	20.3%
1	64877	35.6%
2	45213	24.8%
3	19794	10.9%
4	2551	1.4%
5	519	0.3%
6	580	0.3%
7	65	< 0.1%
8	35	< 0.1%
9	12	< 0.1%

Value	Count	Frequency (%)
21	1	< 0.1%
17	1	< 0.1%
15	2	< 0.1%
14	1	< 0.1%
13	3	< 0.1%
12	2	< 0.1%
10	2	< 0.1%
9	12	< 0.1%
8	35	< 0.1%
7	65	< 0.1%

HLF_BTH
Real number (ℝ)

Missing Zeros

Distinct	8
Distinct (%)	< 0.1%
Missing	11509
Missing (%)	6.3%
Infinite	0
Infinite (%)	0.0%
Mean	0.22192546

Minimum	0
Maximum	7
Zeros	135661
Zeros (%)	74.4%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	7
Range	7
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.46002771
Coefficient of variation (CV)	2.0728929
Kurtosis	5.6723827
Mean	0.22192546
Median Absolute Deviation (MAD)	0
Skewness	2.1362235
Sum	37890
Variance	0.2116255
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
0	135661	74.4%
1	32695	17.9%
2	1983	1.1%
3	361	0.2%
4	23	< 0.1%
5	7	< 0.1%
6	2	< 0.1%
7	1	< 0.1%
(Missing)	11509	6.3%

Value	Count	Frequency (%)
0	135661	74.4%
1	32695	17.9%
2	1983	1.1%
3	361	0.2%
4	23	< 0.1%
5	7	< 0.1%
6	2	< 0.1%
7	1	< 0.1%

Value	Count	Frequency (%)
7	1	< 0.1%
6	2	< 0.1%
5	7	< 0.1%
4	23	< 0.1%
3	361	0.2%
2	1983	1.1%
1	32695	17.9%
0	135661	74.4%

KITCHENS
Real number (ℝ)

High correlation Missing Zeros

Distinct	6
Distinct (%)	< 0.1%
Missing	11718
Missing (%)	6.4%
Infinite	0
Infinite (%)	0.0%
Mean	1.0518813

Minimum	0
Maximum	5
Zeros	36863
Zeros (%)	20.2%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	1
Q3	1
95-th percentile	3
Maximum	5
Range	5
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.8053745
Coefficient of variation (CV)	0.76565153
Kurtosis	0.7498689
Mean	1.0518813
Median Absolute Deviation (MAD)	0
Skewness	0.8745803
Sum	179371
Variance	0.64862808
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
1	102061	56.0%
0	36863	20.2%
2	17625	9.7%
3	13841	7.6%
4	133	0.1%
5	1	< 0.1%
(Missing)	11718	6.4%

Value	Count	Frequency (%)
0	36863	20.2%
1	102061	56.0%
2	17625	9.7%
3	13841	7.6%
4	133	0.1%
5	1	< 0.1%

Value	Count	Frequency (%)
5	1	< 0.1%
4	133	0.1%
3	13841	7.6%
2	17625	9.7%
1	102061	56.0%
0	36863	20.2%

TT_RMS
Real number (ℝ)

High correlation Missing

Distinct	20
Distinct (%)	< 0.1%
Missing	48829
Missing (%)	26.8%
Infinite	0
Infinite (%)	0.0%
Mean	6.940583

Minimum	1
Maximum	20
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	4
median	6
Q3	9
95-th percentile	15
Maximum	20
Range	19
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	4.0097978
Coefficient of variation (CV)	0.57773214
Kurtosis	0.54651164
Mean	6.940583
Median Absolute Deviation (MAD)	2
Skewness	1.1306302
Sum	925964
Variance	16.078479
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
4	24165	13.3%
5	18593	10.2%
3	15940	8.7%
6	15592	8.6%
7	10547	5.8%
8	7496	4.1%
10	5715	3.1%
12	5159	2.8%
9	4870	2.7%
2	4729	2.6%
Other values (10)	20607	11.3%
(Missing)	48829	26.8%

Value	Count	Frequency (%)
1	697	0.4%
2	4729	2.6%
3	15940	8.7%
4	24165	13.3%
5	18593	10.2%
6	15592	8.6%
7	10547	5.8%
8	7496	4.1%
9	4870	2.7%
10	5715	3.1%

Value	Count	Frequency (%)
20	598	0.3%
19	183	0.1%
18	2387	1.3%
17	1286	0.7%
16	993	0.5%
15	4658	2.6%
14	3195	1.8%
13	2332	1.3%
12	5159	2.8%
11	4278	2.3%

BDRM_COND
Categorical

High correlation Imbalance Missing

Distinct	5
Distinct (%)	< 0.1%
Missing	110500
Missing (%)	60.6%
Memory size	1.4 MiB

A - Average	56687
G - Good	13194
E - Excellent	962
F - Fair	837
P - Poor	62

Length

Max length	13
Median length	11
Mean length	10.437498
Min length	8

Characters and Unicode

Total characters	748807
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	A - Average
2nd row	A - Average
3rd row	A - Average
4th row	A - Average
5th row	A - Average

Common Values

Value	Count	Frequency (%)
A - Average	56687	31.1%
G - Good	13194	7.2%
E - Excellent	962	0.5%
F - Fair	837	0.5%
P - Poor	62	< 0.1%
(Missing)	110500	60.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
	71742	33.3%
a	56687	26.3%
average	56687	26.3%
g	13194	6.1%
good	13194	6.1%
e	962	0.4%
excellent	962	0.4%
f	837	0.4%
fair	837	0.4%
p	62	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
	143484	19.2%
e	115298	15.4%
A	113374	15.1%
-	71742	9.6%
r	57586	7.7%
a	57524	7.7%
v	56687	7.6%
g	56687	7.6%
o	26512	3.5%
G	26388	3.5%
Other values (10)	23525	3.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	748807	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	143484	19.2%
e	115298	15.4%
A	113374	15.1%
-	71742	9.6%
r	57586	7.7%
a	57524	7.7%
v	56687	7.6%
g	56687	7.6%
o	26512	3.5%
G	26388	3.5%
Other values (10)	23525	3.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	748807	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	143484	19.2%
e	115298	15.4%
A	113374	15.1%
-	71742	9.6%
r	57586	7.7%
a	57524	7.7%
v	56687	7.6%
g	56687	7.6%
o	26512	3.5%
G	26388	3.5%
Other values (10)	23525	3.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	748807	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	143484	19.2%
e	115298	15.4%
A	113374	15.1%
-	71742	9.6%
r	57586	7.7%
a	57524	7.7%
v	56687	7.6%
g	56687	7.6%
o	26512	3.5%
G	26388	3.5%
Other values (10)	23525	3.1%

FIREPLACES
Real number (ℝ)

Missing Zeros

Distinct	13
Distinct (%)	< 0.1%
Missing	49534
Missing (%)	27.2%
Infinite	0
Infinite (%)	0.0%
Mean	0.34416162

Minimum	0
Maximum	12
Zeros	96980
Zeros (%)	53.2%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	2
Maximum	12
Range	12
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.68600397
Coefficient of variation (CV)	1.9932611
Kurtosis	22.273269
Mean	0.34416162
Median Absolute Deviation (MAD)	0
Skewness	3.4407165
Sum	45673
Variance	0.47060145
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
0	96980	53.2%
1	28983	15.9%
2	5085	2.8%
3	917	0.5%
4	359	0.2%
5	167	0.1%
6	114	0.1%
7	48	< 0.1%
8	34	< 0.1%
9	12	< 0.1%
Other values (3)	9	< 0.1%
(Missing)	49534	27.2%

Value	Count	Frequency (%)
0	96980	53.2%
1	28983	15.9%
2	5085	2.8%
3	917	0.5%
4	359	0.2%
5	167	0.1%
6	114	0.1%
7	48	< 0.1%
8	34	< 0.1%
9	12	< 0.1%

Value	Count	Frequency (%)
12	2	< 0.1%
11	4	< 0.1%
10	3	< 0.1%
9	12	< 0.1%
8	34	< 0.1%
7	48	< 0.1%
6	114	0.1%
5	167	0.1%
4	359	0.2%
3	917	0.5%

NUM_PARKING
Real number (ℝ)

High correlation Missing Skewed Zeros

Distinct	23
Distinct (%)	< 0.1%
Missing	48623
Missing (%)	26.7%
Infinite	0
Infinite (%)	0.0%
Mean	1.3289427

Minimum	0
Maximum	210
Zeros	58524
Zeros (%)	32.1%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	2
95-th percentile	5
Maximum	210
Range	210
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	2.411295
Coefficient of variation (CV)	1.8144461
Kurtosis	1663.0013
Mean	1.3289427
Median Absolute Deviation (MAD)	1
Skewness	29.679935
Sum	177572
Variance	5.8143437
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=23)

Value	Count	Frequency (%)
0	58524	32.1%
1	29227	16.0%
2	21830	12.0%
3	8748	4.8%
4	8222	4.5%
6	3011	1.7%
5	2636	1.4%
8	631	0.3%
7	554	0.3%
10	95	0.1%
Other values (13)	141	0.1%
(Missing)	48623	26.7%

Value	Count	Frequency (%)
0	58524	32.1%
1	29227	16.0%
2	21830	12.0%
3	8748	4.8%
4	8222	4.5%
5	2636	1.4%
6	3011	1.7%
7	554	0.3%
8	631	0.3%
9	88	< 0.1%

Value	Count	Frequency (%)
210	1	< 0.1%
125	24	< 0.1%
56	1	< 0.1%
22	1	< 0.1%
20	1	< 0.1%
18	1	< 0.1%
17	1	< 0.1%
16	3	< 0.1%
14	5	< 0.1%
13	2	< 0.1%

Interactions

Correlations

	BDRM_COND	BED_RMS	CITY	FIREPLACES	FULL_BTH	GROSS_AREA	HLF_BTH	KITCHENS	LIVING_AREA	NUM_BLDGS	NUM_PARKING	RES_FLOOR	STRUCTURE_CLASS	TT_RMS	YR_BUILT	YR_REMODEL	ZIP_CODE
BDRM_COND	1.000	0.026	0.148	0.051	0.064	1.000	0.069	0.000	1.000	0.000	1.000	0.022	0.364	0.127	0.000	0.000	0.127
BED_RMS	0.026	1.000	0.206	0.034	0.659	0.898	0.171	0.696	0.873	0.003	0.449	0.742	0.138	0.940	-0.147	0.277	0.123
CITY	0.148	0.206	1.000	0.045	0.078	0.010	0.074	0.183	0.010	0.006	0.026	0.021	0.259	0.220	0.000	0.021	0.694
FIREPLACES	0.051	0.034	0.045	1.000	0.044	0.103	0.253	-0.181	0.103	0.002	0.125	0.057	0.099	0.054	-0.062	0.104	-0.011
FULL_BTH	0.064	0.659	0.078	0.044	1.000	0.311	0.193	0.859	0.343	0.017	0.233	0.433	0.065	0.664	-0.060	0.233	0.052
GROSS_AREA	1.000	0.898	0.010	0.103	0.311	1.000	0.141	0.245	0.970	0.000	0.519	0.775	0.102	0.925	-0.104	0.243	0.070
HLF_BTH	0.069	0.171	0.074	0.253	0.193	0.141	1.000	0.136	0.143	0.031	0.220	0.220	0.103	0.178	0.091	0.190	0.068
KITCHENS	0.000	0.696	0.183	-0.181	0.859	0.245	0.136	1.000	0.222	0.007	0.223	0.417	0.225	0.721	-0.165	0.066	0.097
LIVING_AREA	1.000	0.873	0.010	0.103	0.343	0.970	0.143	0.222	1.000	0.000	0.449	0.790	0.096	0.900	-0.104	0.248	0.004
NUM_BLDGS	0.000	0.003	0.006	0.002	0.017	0.000	0.031	0.007	0.000	1.000	0.000	0.000	0.000	0.003	0.000	0.000	0.003
NUM_PARKING	1.000	0.449	0.026	0.125	0.233	0.519	0.220	0.223	0.449	0.000	1.000	0.311	0.039	0.457	0.142	0.166	0.286
RES_FLOOR	0.022	0.742	0.021	0.057	0.433	0.775	0.220	0.417	0.790	0.000	0.311	1.000	0.122	0.767	-0.161	0.197	-0.024
STRUCTURE_CLASS	0.364	0.138	0.259	0.099	0.065	0.102	0.103	0.225	0.096	0.000	0.039	0.122	1.000	0.188	1.000	0.062	0.229
TT_RMS	0.127	0.940	0.220	0.054	0.664	0.925	0.178	0.721	0.900	0.003	0.457	0.767	0.188	1.000	-0.176	0.282	0.125
YR_BUILT	0.000	-0.147	0.000	-0.062	-0.060	-0.104	0.091	-0.165	-0.104	0.000	0.142	-0.161	1.000	-0.176	1.000	0.055	0.160
YR_REMODEL	0.000	0.277	0.021	0.104	0.233	0.243	0.190	0.066	0.248	0.000	0.166	0.197	0.062	0.282	0.055	1.000	0.007
ZIP_CODE	0.127	0.123	0.694	-0.011	0.052	0.070	0.068	0.097	0.004	0.003	0.286	-0.024	0.229	0.125	0.160	0.007	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

	CITY	ZIP_CODE	NUM_BLDGS	LU_DESC	BLDG_TYPE	RES_FLOOR	LAND_SF	GROSS_AREA	LIVING_AREA	LAND_VALUE	BLDG_VALUE	TOTAL_VALUE	GROSS_TAX	YR_BUILT	YR_REMODEL	STRUCTURE_CLASS	BED_RMS	FULL_BTH	KITCHENS	TT_RMS	BDRM_COND	NUM_PARKING
0	EAST BOSTON	2128.0	1	THREE-FAM DWELLING	RE - Row End	3.0	1,150	3353.0	2202.0	197,600	594,400	792,000	$8,632.80	1900.0	NaN	NaN	6.0	3.0	3.0	12.0	NaN	3.0
1	EAST BOSTON	2128.0	1	THREE-FAM DWELLING	RM - Row Middle	3.0	1,150	3047.0	2307.0	198,500	619,700	818,200	$8,918.38	1920.0	2000.0	NaN	3.0	3.0	3.0	9.0	NaN	0.0
2	EAST BOSTON	2128.0	1	THREE-FAM DWELLING	RM - Row Middle	3.0	1,150	3392.0	2268.0	199,100	605,300	804,400	$8,767.96	1905.0	1985.0	NaN	5.0	3.0	3.0	13.0	NaN	0.0
3	EAST BOSTON	2128.0	1	THREE-FAM DWELLING	RM - Row Middle	3.0	1,150	3108.0	2028.0	199,700	535,600	735,300	$8,014.77	1900.0	1991.0	NaN	5.0	3.0	3.0	11.0	NaN	0.0
4	EAST BOSTON	2128.0	1	TWO-FAM DWELLING	RE - Row End	3.0	2,010	3700.0	2546.0	230,200	501,400	731,600	$7,974.44	1900.0	1978.0	NaN	6.0	3.0	2.0	13.0	NaN	0.0
5	EAST BOSTON	2128.0	1	THREE-FAM DWELLING	DK - Decker	3.0	2,500	6278.0	4362.0	263,800	1,037,400	1,301,200	$14,183.08	1900.0	2018.0	NaN	13.0	6.0	3.0	20.0	NaN	0.0
6	EAST BOSTON	2128.0	1	THREE-FAM DWELLING	DK - Decker	3.0	2,500	6432.0	4296.0	264,700	1,003,200	1,267,900	$13,820.11	1900.0	2009.0	NaN	14.0	5.0	3.0	20.0	NaN	0.0
7	EAST BOSTON	2128.0	1	THREE-FAM DWELLING	DK - Decker	3.0	2,500	6048.0	4080.0	265,300	885,400	1,150,700	$12,542.63	1900.0	NaN	NaN	11.0	3.0	3.0	16.0	NaN	0.0
8	EAST BOSTON	2128.0	1	THREE-FAM DWELLING	DK - Decker	3.0	2,500	4339.0	2937.0	265,900	619,300	885,200	$9,648.68	1900.0	1998.0	NaN	5.0	3.0	3.0	14.0	NaN	0.0
9	EAST BOSTON	2128.0	1	THREE-FAM DWELLING	DK - Decker	3.0	2,500	4659.0	3241.0	226,700	811,000	1,037,700	$11,310.93	1900.0	2020.0	NaN	6.0	3.0	3.0	14.0	NaN	0.0

	CITY	ZIP_CODE	NUM_BLDGS	LU_DESC	BLDG_TYPE	RES_FLOOR	LAND_SF	GROSS_AREA	LIVING_AREA	LAND_VALUE	BLDG_VALUE	TOTAL_VALUE	GROSS_TAX	YR_BUILT	YR_REMODEL	STRUCTURE_CLASS	BED_RMS	FULL_BTH	HLF_BTH	KITCHENS	TT_RMS	BDRM_COND	FIREPLACES	NUM_PARKING
182232	BRIGHTON	2135.0	1	SINGLE FAM DWELLING	SD - Semi-Det	2.0	3,778	4240.0	2390.4	289,500	633,400	922,900	$10,059.61	1920.0	NaN	NaN	7.0	2.0	1.0	1.0	10.0	NaN	2.0	3.0
182233	BRIGHTON	2135.0	1	TWO-FAM DWELLING	CV - Conventional	2.5	5,333	4609.0	2951.6	365,300	750,000	1,115,300	$12,156.77	1920.0	NaN	NaN	5.0	2.0	0.0	2.0	11.0	NaN	0.0	3.0
182234	BRIGHTON	2135.0	1	CONDO MAIN	FS - Free Standing	2.0	4,485	NaN	NaN	0	0	0	$-	1999.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
182235	BRIGHTON	2135.0	1	RESIDENTIAL CONDO	FS - Free Standing	2.0	2,777	2777.0	1410.0	0	545,100	545,100	$5,941.59	1920.0	NaN	NaN	3.0	1.0	0.0	1.0	8.0	A - Average	1.0	1.0
182236	BRIGHTON	2135.0	1	RESIDENTIAL CONDO	FS - Free Standing	1.0	1,401	1401.0	1401.0	0	494,800	494,800	$5,393.32	1920.0	NaN	NaN	2.0	1.0	0.0	1.0	7.0	A - Average	1.0	1.0
182237	BRIGHTON	2135.0	1	CITY OF BOSTON	99 - Vacant	NaN	5,931	NaN	NaN	240,500	0	240,500	$-	NaN	NaN	NaN	NaN	0.0	0.0	0.0	NaN	NaN	NaN	NaN
182238	BRIGHTON	2135.0	1	RES LAND (Unusable)	99 - Vacant	NaN	4,588	NaN	NaN	72,800	0	72,800	$793.52	NaN	NaN	NaN	NaN	0.0	0.0	0.0	NaN	NaN	NaN	NaN
182239	BRIGHTON	2135.0	1	THREE-FAM DWELLING	CV - Conventional	2.5	7,380	4291.0	2834.4	464,400	850,500	1,314,900	$14,332.41	1920.0	1990.0	NaN	6.0	3.0	0.0	3.0	12.0	NaN	0.0	2.0
182240	BRIGHTON	2135.0	1	STRIP CTR STORES	319 - STRIP RETAIL/ OFFICE	NaN	12,500	14520.0	7260.0	990,900	1,458,800	2,459,200	$62,143.98	1947.0	2016.0	C - Brick/Concr	NaN	0.0	0.0	0.0	NaN	NaN	NaN	NaN
182241	BRIGHTON	2135.0	1	OTHER EXEMPT BLDG	973 - ADMINISTRATIVE BLDG	NaN	34,125	7386.0	7386.0	2,138,600	1,342,900	3,489,000	$-	1900.0	NaN	C - Brick/Concr	NaN	0.0	0.0	0.0	NaN	NaN	NaN	NaN

Duplicate rows

Most frequently occurring

	CITY	ZIP_CODE	NUM_BLDGS	LU_DESC	BLDG_TYPE	RES_FLOOR	LAND_SF	GROSS_AREA	LIVING_AREA	BLDG_VALUE	TOTAL_VALUE	GROSS_TAX	YR_BUILT	YR_REMODEL	STRUCTURE_CLASS	BED_RMS	TT_RMS	BDRM_COND	FIREPLACES	NUM_PARKING	# duplicates
245	BOSTON	2111.0	1	CONDO PARKING (RES)	NoBld	NaN	NaN	NaN	NaN	74,600	74,600	$813.14	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	305
966	BOSTON	2118.0	1	CONDO PARKING (RES)	NoBld	NaN	NaN	NaN	NaN	60,000	60,000	$654.00	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	281
330	BOSTON	2114.0	1	CONDO PARKING (RES)	NoBld	NaN	NaN	NaN	NaN	38,000	38,000	$414.20	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	274
2762	SOUTH BOSTON	2127.0	1	CONDO PARKING (RES)	NoBld	NaN	NaN	NaN	NaN	40,000	40,000	$436.00	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	269
331	BOSTON	2114.0	1	CONDO PARKING (RES)	NoBld	NaN	NaN	NaN	NaN	47,000	47,000	$512.30	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	261
510	BOSTON	2115.0	1	CONDO PARKING (RES)	HR - High Rise	NaN	NaN	NaN	NaN	60,000	60,000	$654.00	2015.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	240
964	BOSTON	2118.0	1	CONDO PARKING (RES)	NoBld	NaN	NaN	NaN	NaN	48,000	48,000	$523.20	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	231
2776	SOUTH BOSTON	2127.0	1	CONDO PARKING (RES)	NaN	NaN	NaN	NaN	NaN	43,000	43,000	$468.70	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	215
958	BOSTON	2118.0	1	CONDO PARKING (RES)	NoBld	NaN	NaN	NaN	NaN	40,000	40,000	$436.00	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	175
329	BOSTON	2114.0	1	CONDO PARKING (RES)	NoBld	NaN	NaN	NaN	NaN	26,600	26,600	$289.94	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	147

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category